Release 10.1A: OpenEdge Development:
Progress 4GL Reference

PROC-HANDLE function

Returns a value in the appropriate data type (usually INTEGER) that is a unique identifier for a stored procedure.

Syntax

PROC-HANDLE

Example

This procedure runs the stored procedure pcust and writes the procedure handle to the variable handle. It writes the results of the stored procedure identified by this procedure handle into the Progress-supplied buffer, proc-text-buffer, and displays it.

DEFINE VAR handle AS INTEGER. RUN STORED-PROCEDURE pcust handle = PROC-HANDLE (10, OUTPUT 0, OUTPUT 0). FOR EACH proc-text-buffer WHERE PROC-HANDLE = handle: DISPLAY proc-text. END. CLOSE STORED-PROCEDURE pcust WHERE PROC-HANDLE = handle.

Notes

Progress Software recommends that you specify a procedure handle for each stored procedure that you run.
You do not have to specify a handle if there is only one active stored procedure and you do not include SQL statements in the OpenEdge application. In the case of ORACLE only, the DataServer passes SQL statements to the ORACLE RDBMS and uses the default system handle in the process.

For more information on using this function, see the OpenEdge DataServer Guides, OpenEdge Data Management: DataServer for Microsoft SQL Server , OpenEdge Data Management: DataServer for ODBC , and OpenEdge Data Management: DataServer for ORACLE .

See also

CLOSE STORED-PROCEDURE statement, PROC-STATUS function, RUN STORED-PROCEDURE statement